The SAS^® Revenue Optimization %TKMI_JOB_RO attr_hier_job task might generate the following error in the <DDMMYYY_HH_MM_SS>_attr_hier_job.log file when the CLEAN_ATTR_HIER option is used:

ERROR: ORACLE execute error: ORA-00911: invalid character.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
NOTE: Statement not executed due to NOEXEC option.
NOTE: Statement not executed due to NOEXEC option.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.02 seconds
      cpu time            0.01 seconds
      
the value of di_dm_trans_update syscc is 1012

This error occurs after the dangling nodes have been deleted when the process checks to see whether model groups have been made invalid.

To work around this issue, perform the following steps:

1. Run the %TKMI_JOB_RO task without the CLEAN_ATTR_HIER option.

   %tkmi_job_ro(run_only=%bquote(attr_hier_job ), debug=1);
   

2. Clean up the dangling nodes with the option to update the model groups disabled.

   %di_purge_dangling_nodes_attr(di_data=di_data, di_trans=di_trans, hier_type=1;update_model_group=0);
   %di_purge_dangling_nodes_attr(di_data=di_data, di_trans=di_trans, hier_type=2;update_model_group=0);
   

3. Disable any invalid model groups. This step is optional as the model_group_validation task is run as part of the %TKM_JOB_RO est_start service task.

   %tkmi_job_ro(run_only=%bquote(model_group_validation ), debug=1);
   

Operating System and Release Information